{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "offers = pd.read_csv(\"offers.csv\")\n",
    "trans = pd.read_csv(\"transactions.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Offer #</th>\n",
       "      <th>Campaign</th>\n",
       "      <th>Varietal</th>\n",
       "      <th>Minimum Qty (kg)</th>\n",
       "      <th>Discount (%)</th>\n",
       "      <th>Origin</th>\n",
       "      <th>Past Peak</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>January</td>\n",
       "      <td>Malbec</td>\n",
       "      <td>72</td>\n",
       "      <td>56</td>\n",
       "      <td>France</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>January</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>72</td>\n",
       "      <td>17</td>\n",
       "      <td>France</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>February</td>\n",
       "      <td>Espumante</td>\n",
       "      <td>144</td>\n",
       "      <td>32</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>February</td>\n",
       "      <td>Champagne</td>\n",
       "      <td>72</td>\n",
       "      <td>48</td>\n",
       "      <td>France</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>February</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>144</td>\n",
       "      <td>44</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Offer #  Campaign            Varietal  Minimum Qty (kg)  Discount (%)  \\\n",
       "0        1   January              Malbec                72            56   \n",
       "1        2   January          Pinot Noir                72            17   \n",
       "2        3  February           Espumante               144            32   \n",
       "3        4  February           Champagne                72            48   \n",
       "4        5  February  Cabernet Sauvignon               144            44   \n",
       "\n",
       "        Origin  Past Peak  \n",
       "0       France      False  \n",
       "1       France      False  \n",
       "2       Oregon       True  \n",
       "3       France       True  \n",
       "4  New Zealand       True  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "offers.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Customer Last Name</th>\n",
       "      <th>Offer #</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Smith</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Smith</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Johnson</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Johnson</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Johnson</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Customer Last Name  Offer #\n",
       "0              Smith        2\n",
       "1              Smith       24\n",
       "2            Johnson       17\n",
       "3            Johnson       24\n",
       "4            Johnson       26"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trans.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged = pd.merge(offers, trans, on=\"Offer #\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(324, 2)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trans.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged.to_csv(\"merged.csv\", header=True, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "offers.columns = [\"offer_id\", \"campaign\", \"varietal\", \"min_qty\", \"discount\", \"origin\", \"past_peak\"]\n",
    "trans.columns = [\"customer_name\", \"offer_id\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "trans['n'] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# join the offers and transactions table\n",
    "df = pd.merge(offers, trans)\n",
    "# create a \"pivot table\" which will give us the number of times each customer responded to a given offer\n",
    "matrix = df.pivot_table(index=['customer_name'], columns=['offer_id'], values='n')\n",
    "# a little tidying up. fill NA values with 0 and make the index into a column\n",
    "matrix = matrix.fillna(0).reset_index()\n",
    "# save a list of the 0/1 columns. we'll use these a bit later\n",
    "x_cols = matrix.columns[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>offer_id</th>\n",
       "      <th>customer_name</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "      <th>31</th>\n",
       "      <th>32</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Adams</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Allen</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Anderson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bailey</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Baker</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Barnes</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bell</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bennett</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Brooks</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Brown</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Butler</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Campbell</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Carter</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Clark</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Collins</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Cook</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Cooper</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Cox</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Cruz</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Davis</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Diaz</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Edwards</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Evans</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Fisher</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Flores</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Foster</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Garcia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Gomez</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Gonzalez</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Gray</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Reed</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Reyes</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Richardson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Rivera</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Roberts</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Robinson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Rodriguez</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Rogers</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Ross</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Russell</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Sanchez</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Sanders</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Scott</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Smith</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Stewart</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Sullivan</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Taylor</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Thomas</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Thompson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Torres</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Turner</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Walker</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Ward</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Watson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>White</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Williams</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Wilson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Wood</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Wright</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Young</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "offer_id customer_name    1    2    3    4    5    6    7    8    9 ...    23  \\\n",
       "0                Adams  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "1                Allen  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0 ...   0.0   \n",
       "2             Anderson  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "3               Bailey  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "4                Baker  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "5               Barnes  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "6                 Bell  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "7              Bennett  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "8               Brooks  0.0  0.0  1.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "9                Brown  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "10              Butler  1.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "11            Campbell  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "12              Carter  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "13               Clark  0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "14             Collins  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "15                Cook  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "16              Cooper  0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "17                 Cox  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "18                Cruz  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "19               Davis  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "20                Diaz  0.0  0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0 ...   0.0   \n",
       "21             Edwards  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "22               Evans  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "23              Fisher  1.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "24              Flores  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "25              Foster  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0 ...   1.0   \n",
       "26              Garcia  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "27               Gomez  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "28            Gonzalez  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0 ...   0.0   \n",
       "29                Gray  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "..                 ...  ...  ...  ...  ...  ...  ...  ...  ...  ... ...   ...   \n",
       "70                Reed  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "71               Reyes  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0 ...   1.0   \n",
       "72          Richardson  0.0  0.0  1.0  0.0  0.0  1.0  0.0  0.0  0.0 ...   0.0   \n",
       "73              Rivera  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "74             Roberts  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "75            Robinson  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "76           Rodriguez  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "77              Rogers  0.0  0.0  1.0  0.0  0.0  0.0  1.0  1.0  0.0 ...   0.0   \n",
       "78                Ross  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "79             Russell  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "80             Sanchez  0.0  0.0  0.0  1.0  1.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "81             Sanders  1.0  0.0  0.0  1.0  1.0  1.0  0.0  0.0  1.0 ...   0.0   \n",
       "82               Scott  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0 ...   1.0   \n",
       "83               Smith  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "84             Stewart  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "85            Sullivan  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "86              Taylor  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "87              Thomas  1.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  1.0 ...   0.0   \n",
       "88            Thompson  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0 ...   0.0   \n",
       "89              Torres  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "90              Turner  0.0  0.0  0.0  1.0  0.0  1.0  0.0  0.0  0.0 ...   0.0   \n",
       "91              Walker  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "92                Ward  0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "93              Watson  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0 ...   0.0   \n",
       "94               White  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "95            Williams  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "96              Wilson  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0   \n",
       "97                Wood  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0   \n",
       "98              Wright  0.0  0.0  0.0  1.0  0.0  1.0  0.0  0.0  0.0 ...   0.0   \n",
       "99               Young  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  1.0 ...   0.0   \n",
       "\n",
       "offer_id   24   25   26   27   28   29   30   31   32  \n",
       "0         0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "1         0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  \n",
       "2         1.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "3         0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  \n",
       "4         0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "5         0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "6         1.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "7         0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0  \n",
       "8         0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "9         0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "10        0.0  0.0  0.0  0.0  1.0  0.0  1.0  0.0  0.0  \n",
       "11        1.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "12        0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "13        0.0  0.0  0.0  0.0  1.0  0.0  0.0  1.0  0.0  \n",
       "14        0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  \n",
       "15        1.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "16        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  \n",
       "17        1.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "18        0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "19        0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "20        0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "21        0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  \n",
       "22        0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  \n",
       "23        0.0  0.0  0.0  0.0  1.0  0.0  1.0  1.0  0.0  \n",
       "24        1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "25        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "26        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "27        0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  \n",
       "28        0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "29        0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "..        ...  ...  ...  ...  ...  ...  ...  ...  ...  \n",
       "70        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "71        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "72        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "73        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "74        0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "75        0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0  \n",
       "76        0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "77        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "78        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "79        0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "80        0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "81        0.0  1.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "82        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "83        1.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "84        0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "85        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "86        0.0  0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "87        0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "88        0.0  1.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  \n",
       "89        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "90        0.0  0.0  0.0  1.0  0.0  0.0  0.0  1.0  0.0  \n",
       "91        0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0  \n",
       "92        0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "93        0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0  \n",
       "94        0.0  1.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  \n",
       "95        0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "96        0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  \n",
       "97        0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "98        0.0  0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  \n",
       "99        0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  1.0  \n",
       "\n",
       "[100 rows x 33 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([ 1,  2,  3,  4,  5,  6,  7,  8,  9, 10, 11, 12, 13, 14, 15, 16, 17, 18,\n",
       "       19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32],\n",
       "      dtype='object', name='offer_id')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    24\n",
       "6    17\n",
       "4    14\n",
       "3    14\n",
       "2    14\n",
       "0    12\n",
       "5     5\n",
       "Name: cluster, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.cluster import KMeans\n",
    "\n",
    "cluster = KMeans(n_clusters=7)\n",
    "# slice matrix so we only include the 0/1 indicator columns in the clustering\n",
    "matrix['cluster'] = cluster.fit_predict(matrix[matrix.columns[2:]])\n",
    "matrix.cluster.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['customer_name',               1,               2,               3,\n",
       "                     4,               5,               6,               7,\n",
       "                     8,               9,              10,              11,\n",
       "                    12,              13,              14,              15,\n",
       "                    16,              17,              18,              19,\n",
       "                    20,              21,              22,              23,\n",
       "                    24,              25,              26,              27,\n",
       "                    28,              29,              30,              31,\n",
       "                    32,       'cluster'],\n",
       "      dtype='object', name='offer_id')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matrix.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>offer_id</th>\n",
       "      <th>customer_name</th>\n",
       "      <th>cluster</th>\n",
       "      <th>x</th>\n",
       "      <th>y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Adams</td>\n",
       "      <td>6</td>\n",
       "      <td>1.007580</td>\n",
       "      <td>0.108215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Allen</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.287539</td>\n",
       "      <td>0.044715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Anderson</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.392032</td>\n",
       "      <td>1.038391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bailey</td>\n",
       "      <td>6</td>\n",
       "      <td>0.699477</td>\n",
       "      <td>-0.022542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Baker</td>\n",
       "      <td>4</td>\n",
       "      <td>0.088183</td>\n",
       "      <td>-0.471695</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "offer_id customer_name  cluster         x         y\n",
       "0                Adams        6  1.007580  0.108215\n",
       "1                Allen        1 -0.287539  0.044715\n",
       "2             Anderson        2 -0.392032  1.038391\n",
       "3               Bailey        6  0.699477 -0.022542\n",
       "4                Baker        4  0.088183 -0.471695"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.decomposition import PCA\n",
    "\n",
    "pca = PCA(n_components=2)\n",
    "matrix['x'] = pca.fit_transform(matrix[x_cols])[:,0]\n",
    "matrix['y'] = pca.fit_transform(matrix[x_cols])[:,1]\n",
    "matrix = matrix.reset_index()\n",
    "\n",
    "customer_clusters = matrix[['customer_name', 'cluster', 'x', 'y']]\n",
    "customer_clusters.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>offer_id</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "      <th>31</th>\n",
       "      <th>32</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "offer_id   1    2    3    4    5    6    7    8    9    10 ...    23   24  \\\n",
       "0         0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0  0.0   \n",
       "1         0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0 ...   0.0  0.0   \n",
       "2         0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0 ...   0.0  1.0   \n",
       "3         0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  0.0 ...   0.0  0.0   \n",
       "4         0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  1.0 ...   0.0  0.0   \n",
       "\n",
       "offer_id   25   26   27   28   29   30   31   32  \n",
       "0         0.0  0.0  0.0  0.0  1.0  1.0  0.0  0.0  \n",
       "1         0.0  0.0  1.0  0.0  0.0  0.0  0.0  0.0  \n",
       "2         0.0  1.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "3         0.0  0.0  0.0  0.0  0.0  1.0  0.0  0.0  \n",
       "4         0.0  0.0  0.0  0.0  0.0  0.0  1.0  0.0  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matrix[x_cols].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.merge(trans, customer_clusters)\n",
    "df = pd.merge(offers, df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "matrix[x_cols].to_csv('pivot.csv', header=True, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "distortions = []\n",
    "for k in range(1,20):\n",
    "    cluster = KMeans(n_clusters=k)\n",
    "    # slice matrix so we only include the 0/1 indicator columns in the clustering\n",
    "    cluster.fit(matrix[matrix.columns[2:]])\n",
    "    distortions.append(cluster.inertia_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[752.6112565545452,\n",
       " 426.62329523948654,\n",
       " 319.3991889765912,\n",
       " 267.43067918369854,\n",
       " 239.6232817035381,\n",
       " 216.35915878449237,\n",
       " 201.9003878192649,\n",
       " 194.76177375435168,\n",
       " 189.54589248782077,\n",
       " 183.97897016041765,\n",
       " 174.4839153168375,\n",
       " 168.3478444104657,\n",
       " 162.0351334442483,\n",
       " 157.19246015258128,\n",
       " 154.27124006754224,\n",
       " 149.7536697714827,\n",
       " 146.2486237694478,\n",
       " 139.97177039638143,\n",
       " 136.14544741551362]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "distortions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEWCAYAAAB8LwAVAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAIABJREFUeJzt3XucVXW9//HXGxARBQEFRQTxgjDY8TqWqZl0MTXzLlkdJbVjFy3taGalmaaVdLSTVh4tSzQz8ZaXoyf5IWpWKmDeb1wSQRBUEFC8gZ/fH9+1mz3Dnpk1w+zZe2a/n4/Heuy11l5r789eDPuzv5f1/SoiMDMza6pHpQMwM7Pq5ARhZmYlOUGYmVlJThBmZlaSE4SZmZXkBGFmZiU5QVgukr4o6YGi7ZC0XSVj6igd+VkkvSDpEx3xWtVA0huStinD6zb6e2ry3Mjs36RXR7+vtY0ThP1L9uX2VvalUFh+Uem44F9fKCHp4ib7D832X5Xzde6V9KWyBNn6e18l6d0m1/ezHfj6B0l6WNKbkl6TdK2kLdtw/lrXJiI2ioi5HRWjdS1OENbUZ7IvhcJycqUDKjIH+GyTX5bHAs9XKJ72mNjk+l7f1heQ1LPEviOBPwA/BzYFdgDeAR6QNHBdg7ba5ARh6+JASXMlvSrpp5J6AEjqIeksSfMkLZF0taSNs+cmSTotWx+W/fr/Wra9naSlktTM+70MPAF8Kjt+ELAncFvxQZL2kPQ3Sa9LekzSvtn+C4CPAL8oUTr6hKRZkpZJ+mUhhpY+S/b8Mdlzr0n6XnsvpKS67Bf865KeknRw0XNXSbpM0p2S3gTGNTlXwEXA+RFxbUS8FREvA18C3gC+mR33RUl/lXSppOWSnpX08ZauTXH1WxbHryTdlR3zV0mbS/rv7Lo9K2mXorjOlDRH0kpJT0s6rJ3X5oisdPuB9pxv7ecEYeviMKAe2BU4BDg+2//FbBkHbANsBBS+jO8D9s3WPwrMzR4B9gH+Ei2P/3I1qdQAcDRwK+mXMpCSDvC/wPnAIOB04CZJgyPie8BfgJNLlI4OAnYHdgLGkyWhlj6LpLHAZcAxwBbAJkDuKp2imNcDbgfuBoYAXweulTS66LDPAxcA/YCmdfejgRHADcU7I+J94Cbgk0W7P0S65psC5wA3SxrUyrUpNh44Kzv/HeDvwCPZ9o1AcRXgHFLS2Rg4F/i9pKEtXowmJB0HXAh8IiKebMu5tu6cIKypP2W/YgvLf7Rw7IURsTQiXgT+G/hctv8LwMURMTci3gC+AxydVQ3dB3wkK23sA0wE9srO+2j2fEtuAfbNfsUfS0oYxf4duDMi7oyI9yNiCjADOLCV1/1JRLyefZZpwM45PsuRwB0RcX9EvAOcDbzfyvucXnRtX8327UFKPD+JiHcj4h7gDhquJ8CtEfHX7DO93eQ1N80eF5V4v0VFzwMsAf47It7LqreeAz7dSszFbomImVkMtwBvR8TVEbEGuB74VwkiIm6IiIVZzNcDs4APtuG9TgW+BewbEbPbcJ51ECcIa+rQiBhQtPy6hWPnF63PI/2KJnuc1+S5XsBmETGHVO2xM+nX5R3AwuzXcqsJIiLeIpUQzgI2jYi/NjlkK+Co4iQH7A209sv15aL1VaQv7BY/S/bcv65BRLwJvNbK+/xX0bUtfHFvAczPfvEXv8+wou3ia91UIdGU+oxDi54HeKlJCa343y2PxUXrb5XYLlw3JB0r6dGif4cP0DhZteZbwC8jYkEbzrEO5ARh62J40foIYGG2vpD0RV383GoavkzuI/367h0RL2XbxwIDgUdzvO/VwGnANSWemw9c0yTJbRgRP8meb+vwxS19lkUUXQNJfUnVTG21EBheaMMpep+XirZbivs5YAFwVPHO7PWOAKYW7R7WpI2n+N+tw4Z2lrQV8GvgZGCTiBgAPAk0175Uyn7AWZKO6Ki4rG2cIGxdfEvSQEnDgVNIVQwA1wHflLS1pI2AHwHXR8Tq7Pn7SF8c92fb95Lq3R/Iqipacx+pXv3SEs/9HviMpE9J6impj6R91dDdczGpLSGvlj7LjcBBkvaW1Bs4j/b9n3oIeBM4Q9J6WaP6Z4A/5jk5KxGcTvoy/bykDSRtDvwG6A/8rOjwIcA3svc5CqgD7syea+u1acmGpITzCvyrLaGtjcxPAfsDvyxutLfO4wRhTd2uxv30b2nh2FuBmaRf/f8LXJnt/y3p1/39wD+Bt0kJoOA+UmNrIUE8APQt2m5RJFMjYmmJ5+aTGsy/S/pymk+qqij8rf8cODLrdXNJjrdr9rNExFPASaTupYuAZaRf8m0SEe8CBwMHkKqDfgUcGxHPtuE1ric1ln8ze42ngQ2AvSKiuNrrIWBUdswFwJFFz7f12rQUz9OknlV/JyWefwOaVgfmeZ3HSB0Ifi3pgHWJydpOnjDIrDZI+iLwpYjYu9KxWNfgEoSZmZXkBGFmZiW5isnMzEpyCcLMzErq0sPpbrrppjFy5MhKh2Fm1qXMnDnz1YgY3NpxXTpBjBw5khkzZlQ6DDOzLkXSvNaPchWTmZk1wwnCzMxKcoIwM7OSnCDMzKwkJwgzMyupphLExIkwbVrjfdOmpf1mZtZYTSWI3XeH8eMbksS0aWl7990rG5eZWTXq0vdBtNW4cTB5Mhx+OIwdC88/n7bHjWv9XDOzWlNTJQhIyeBDH4K//Q2OOcbJwcysOTWXIKZNgwcfTOu//e3abRJmZpbUVIIotDlccUXanjChcZuEmZk1qKkEMX16anM46ijo3x/WrEnb06dXOjIzs+rTpeeDqK+vj/YO1rfHHtC3L9xzTwcHZWZW5STNjIj61o6rqRJEsbFj4ZlnKh2FmVn1qtkEUVcHL78My5ZVOhIzs+pU0wkCXIowM2tOzSaIsWPToxOEmVlpNZsgttoK+vSBp5+udCRmZtWpZhNEz54wZoxLEGZmzanZBAGpHcIlCDOz0mo+QcybB2++WelIzMyqT00niEJD9XPPVTYOM7NqVLYEIWm0pEeLlhWSTpU0SNIUSbOyx4HZ8ZJ0iaTZkh6XtGu5YisodHV1NZOZ2drKliAi4rmI2DkidgZ2A1YBtwBnAlMjYhQwNdsGOAAYlS0nApeVK7aC7baDXr3cUG1mVkpnVTF9HJgTEfOAQ4BJ2f5JwKHZ+iHA1ZE8CAyQNLScQfXunZKESxBmZmvrrARxNHBdtr5ZRCwCyB6HZPuHAfOLzlmQ7WtE0omSZkia8corr6xzYB6TycystLInCEm9gYOBG1o7tMS+tYaajYgrIqI+IuoHDx68zvHV1cHs2fDuu+v8UmZm3UpnlCAOAB6JiMXZ9uJC1VH2uCTbvwAYXnTelsDCcgdXV5fmhZg1q9zvZGbWtXRGgvgcDdVLALcBE7L1CcCtRfuPzXoz7QEsL1RFlZPHZDIzK61XOV9cUl/gk8CXi3b/BJgs6QTgReCobP+dwIHAbFKPp+PKGVvB6NEguaHazKypsiaIiFgFbNJk32ukXk1Njw3gpHLGU0rfvjBypEsQZmZN1fSd1AUek8nMbG1OEKQE8dxzqbHazMwSJwhSQ/U778ALL1Q6EjOz6uEEgcdkMjMrxQkCz09tZlaKEwQwYAAMHeoShJlZMSeITF2dSxBmZsWcIDKFQftirdGfzMxqkxNEpq4OVq6El16qdCRmZtXBCSLjMZnMzBpzgsi4q6uZWWNOEJkhQ2DgQJcgzMwKnCAyUqpmcgnCzCxpU4KQNFDSjuUKptLc1dXMrEGrCULSvZL6SxoEPAb8TtLF5Q+t840dC6++Ch0w1bWZWZeXpwSxcUSsAA4HfhcRuwGfKG9YleEhN8zMGuRJEL2yuaPHA3eUOZ6KcoIwM2uQJ0GcB/wZmBMR0yVtA8wqb1iVMXw4bLihG6rNzCDHlKMRcQNwQ9H2XOCIcgZVKT16wJgxLkGYmUG+RurtJU2V9GS2vaOks8ofWmUUxmQyM6t1eaqYfg18B3gPICIeB44uZ1CVVFcHCxbAihWVjsTMrLLyJIi+EfFwk32ryxFMNSg0VD/7bGXjMDOrtDwJ4lVJ2wIBIOlIYFFZo6qgwqB9bqg2s1qXJ0GcBFwOjJH0EnAq8NU8Ly5pgKQbJT0r6RlJH5Y0SNIUSbOyx4HZsZJ0iaTZkh6XtGu7P9U62GYb6N3b7RBmZq0miIiYGxGfAAYDYyJi74h4Iefr/xz4v4gYA+wEPAOcCUyNiFHA1Gwb4ABgVLacCFzWlg/SUXr1gu23d4IwM8vTi+lHkgZExJsRsTIbj+n8HOf1B/YBrgSIiHcj4nXgEGBSdtgk4NBs/RDg6kgeBAZkN+h1uro6VzGZmeWpYjog+2IHICKWAQfmOG8b4BXS2E3/kPQbSRsCm0XEouy1FgFDsuOHAfOLzl+Q7WtE0omSZkia8UqZBk0aOxb++U94662yvLyZWZeQJ0H0lLR+YUPSBsD6LRxf0AvYFbgsInYB3qShOqkUldi31gzREXFFRNRHRP3gwYNzhNF2dXXw/vvw/PNleXkzsy4hT4L4PTBV0gmSjgem0FBF1JIFwIKIeCjbvpGUMBYXqo6yxyVFxw8vOn9LYGGO9+lwHpPJzCxfI/VE4AKgDtgB+GG2r7XzXgbmSxqd7fo48DRwGzAh2zcBuDVbvw04NuvNtAewvFAV1dm23z4Nu+F2CDOrZa2OxQQQEXcBd7Xj9b8OXCupNzAXOI6UlCZLOgF4ETgqO/ZOUtvGbGBVdmxF9OmTuru6BGFmtazVBCHpcOBCUmOysiUion9r50bEo0B9iac+XuLYIN1zURU8JpOZ1bo8bRATgYMjYuOI6B8R/fIkh66uri41Uq/utoOKmJm1LE+CWBwRNfdbuq4O3nsP5sypdCRmZpWRpw1ihqTrgT8B7xR2RsTNZYuqChSPyTR6dMvHmpl1R3lKEP1Jjcb7AZ/JloPKGVQ1GDMmPbodwsxqVZ4Z5SrWm6iS+vVLU5A6QZhZrcrTi6kPcALpHog+hf0RcXwZ46oKHpPJzGpZniqma4DNgU8B95HucF5ZzqCqRV1dmjjo/fcrHYmZWefLkyC2i4izgTcjYhLwaeDfyhtWdRg7FlatghdfrHQkZmadL0+CeC97fF3SB4CNgZFli6iKeEwmM6tleRLEFdmsb2eRxkt6mnRndbdX6OrqBGFmtSjPfRBTszkg7ifN8YCkrcsaVZXYZBMYPNgN1WZWm/KUIG4qse/Gjg6kWtXVuQRhZrWp2RKEpDGkrq0bZwP2FfSnqLtrdzd2LPzxjxABKjWlkZlZN9VSFdNo0h3TA0h3TxesBP6jnEFVk7o6eP11WLwYNt+80tGYmXWeZhNERNwK3CrpwxHx906MqaoUj8nkBGFmtSRPG8RhkvpLWk/SVEmvSvr3skdWJdzV1cxqVZ4EsV9ErCBVNy0Atge+VdaoqsgWW6RxmZwgzKzW5EkQ62WPBwLXRcTSMsZTdaRUzeSurmZWa/IkiNslPUuaOnSqpMHA2+UNq7q4q6uZ1aJWE0REnAl8GKiPiPeAN4FDyh1YNRk7Fl5+GZYtq3QkZmadp6X7ID4WEfcU3wOhxjcCdOsZ5YoVN1TvuWdlYzEz6ywt3QfxUeAeGt8DURA4QZiZdWst3QdxTvZYkzPKFRs5Evr0cUO1mdWWlqqY/rOlEyPi4tZeXNILpDuv1wCrI6Je0iDgetKQ4S8A4yNimVL91c9JvaVWAV+MiEfyfYzy6tkTRo92Q7WZ1ZaWGqn7ZUs98FVgWLZ8BRjbhvcYFxE7R0R9tn0maYTYUcDUbBvgAGBUtpwIXNaG9yg7d3U1s1rTbIKIiHMj4lxgU2DXiDgtIk4DdiNNO9pehwCTsvVJwKFF+6+O5EFggKSh6/A+HaquDubNgzffrHQkZmadI899ECOAd4u23yX/jHIB3C1ppqQTs32bRcQigOxxSLZ/GDC/6NwF2b5GJJ0oaYakGa+88krOMNZdYUymZ5/ttLc0M6uoPBMGXQM8LOkW0hf+YTSUAFqzV0QslDQEmJLdcNecUoNpx1o7Iq4ArgCor69f6/lyKe7JtNtunfWuZmaV02qCiIgLJN0FfCTbdVxE/CPPi0fEwuxxSZZgPggsljQ0IhZlVUhLssMXAMOLTt8SWJjzc5Tddtulxmo3VJtZrchTxUREPBIRP8+WXMlB0oaS+hXWgf2AJ0nzWk/IDpsA3Jqt3wYcq2QPYHmhKqoa9O4No0a5odrMakeeKqb22gy4Jbv7uhfwh4j4P0nTgcmSTgBeBI7Kjr+T1MV1Nqmba9Xdf1FX5wRhZrWjbAkiIuYCO5XY/xrw8RL7AzipXPF0hLFj4bbb4N13U4nCzKw7y1XFZEldHaxZA7NmVToSM7Pya+lO6pWU6EVUEBH9yxJRFSvuybTDDpWNxcys3Foai6nQwHwe8DKpu6uAL5DusK45Y8akCYTcDmFmtSBPFdOnIuJXEbEyIlZExGXAEeUOrBr17QtbbeWurmZWG/IkiDWSviCpp6Qekr5AGnyvJnlMJjOrFXkSxOeB8cDibDkq21eT6urguedSY7WZWXeW507qF6ixKUZbUlcH77wDL7wA225b6WjMzMqn1RKEpO0lTZX0ZLa9o6Szyh9adSoM2udqJjPr7vJUMf0a+A7wHkBEPA4cXc6gqllxV1czs+4sT4LoGxEPN9m3uhzBdAUDBsDQoS5BmFn3lydBvCppW7Kb5iQdCVTNIHqVUFfnEoSZdX95EsRJwOXAGEkvAaeSph2tWYUEEZ02G4WZWedrsReTpB5AfUR8Ihuyu0dErOyc0KrX2LGwciW89BJsuS6Tr5qZVbEWSxAR8T5wcrb+ppND4oZqM6sFeaqYpkg6XdJwSYMKS9kjq2Lu6mpmtSDPfBDHZ4/FczUEsE3Hh1P9Jk6E+noYOLChBDFtGkyfDmecUdnYzMw6Up47qbfujEC6it13h/HjYYstUgli2rS0PXlypSMzM+tYuWaUk/QBYCzQp7AvIq4uV1DVbNy4lAwOPBDmzGlIDuPGVToyM7OOlWeojXOAS7NlHDAROLjMcVW1cePgsMPg7bfhQx9ycjCz7ilPI/WRpDmkX46I40jzTK9f1qiq3LRpMGVKqma66660bmbW3eRJEG9l3V1XS+oPLKFGG6ihcZvD5ZfD++/D4Yen/WZm3UmeNogZkgaQBu2bCbwBNB2bqWZMn97Q5hABu+wCixfDQw+5qsnMupc8vZi+lq3+j6T/A/pnI7rWpOKurBJ8//upPWLYsMrFZGZWDnkaqfcpLMAIYEC2nks2Vek/JN2RbW8t6SFJsyRdL6l3tn/9bHt29vzI9n2kznXwwbDjjnDBBZ5lzsy6lzxtEN8qWs4Gbgd+0Ib3OAUoHpTiQuBnETEKWAackO0/AVgWEdsBP8uOq3o9esDZZ6dpSG+4odLRmJl1nFYTRER8pmj5JPAB0tzUrZK0JfBp4DfZtoCPATdmh0wCDs3WD8m2yZ7/eHZ81Tv88DT8xg9/mBqtzcy6gzwliKYWkJJEHv8NnAEUvjY3AV6PiMKEQwuAQu39MGA+QPb88uz4RiSdKGmGpBmvvPJKO8LveIVSxNNPw803VzoaM7OOkacN4lJJl2TLL4C/AI/lOO8gYElEzCzeXeLQyPFcw46IKyKiPiLqBw8e3FoYneaoo2D0aJcizKz7yNXNtWh9NXBdRPw1x3l7AQdLOpA0REd/UoligKReWSlhS2BhdvwCYDiwQFIvYGNgab6PUXk9e8L3vgfHHgu33QaHHtr6OWZm1UzRCdOiSdoXOD0iDpJ0A3BTRPxR0v8Aj0fErySdBPxbRHxF0tHA4RExvqXXra+vjxkzZrR0SKdavRrGjIH+/WHmzNQN1sys2kiaGRH1rR3XaglC0hOUqOohVQlFROzYxti+DfxR0vnAP4Ars/1XAtdImk0qORzdxtetuF69Uini+OPhf/8XDjqo0hGZmbVfqyUISROz1Wuyxy8Aq8h6HEXEvLJF14pqK0EAvPcebL89DBkCDz7oUoSZVZ+8JYg8vZj2iogzIuKJbDkT+FREzKtkcqhW660H3/0uPPww3H13paMxM2u/PAliQ0l7FzYk7QlsWL6Qur4JE2D4cDj33DRek5lZV5QnQZwA/FLSC5JeAH5FwzSkVkLv3vCd78Df/w733FPpaMzM2id3L6ZsqG9FxPLyhpRfNbZBFLzzDmy7bVruu6/S0ZiZNeiwNghJp2TJYSVwkaRHJO3XEUF2Z+uvD9/+Ntx/vxOEmXVNeaqYjo+IFcB+wBDgOOAnZY2qm/jSl2DzzeG88yodiZlZ2+VJEIWOmgcCv4uIxyg9LIY1scEGaf6Ie+6Bv+a599zMrIrkSRAzJd1NShB/ltSPhsH3rBVf/jIMHpzGaDIz60ry9mI6E9g9IlYBvUnVTJZD375w+unw5z+naUnNzLqKPPNBvB8Rj0TE69n2a7U85Wh7fO1rsMkmLkWYWdfSnvkgrI022gj+8z/T+EwzZ7Z+vJlZNWg2QUjaujMD6e5OPhkGDHApwsy6jpZKEDcCSJraSbF0a/37wze/CbfeCo8+WulozMxa11KC6CHpHGB7Sf/ZdOmsALuTb3wjJYrzz690JGZmrWspQRwNvE2aM6JficXaaMAAOOUUuOkmePLJSkdjZtayPPNBHBARd3VSPG1SzWMxNWfpUthqqzSZ0HXXVToaM6tFHTkfxN8kXSxpRrZcJGnjDoixJg0aBF//Olx/PTz7bKWjMTNrXp4E8VvSQH3js2UF8LtyBtXdrbdeGszvggsa9k2bBhMnNn+OmVlny5Mgto2IcyJibracC2xT7sC6s333TVORXnstzJqVksP48bD77pWOzMysQZ4E8VaTGeX2At4qX0jd37hxcM01aba5ww9PyWHy5LTfzKxa9MpxzFeAq4vaHZYBE8oXUm044gjYe2944AHYc89UqjAzqyZ5xmJ6LCJ2AnYEdoyIXTwW07qbNi01Uu+2G/ztb/C5z3n+ajOrLrnHYoqIFdnEQbaOCm0OkyfD9Olw6KGpV9P48U4SZlY9yjZYn6Q+kh6W9JikpySdm+3fWtJDkmZJul5S72z/+tn27Oz5keWKrdKmT29oc5Dg5ptTW8SNN6Yb6ZwkzKwalHM013eAj2XVUzsD+0vaA7gQ+FlEjCK1Z5yQHX8CsCwitgN+lh3XLZ1xRuMGaSklh9NOg0svhZNOgvc9JZOZVVirjdSSegKfBkYWHx8RF7d0XqRbtN/INtfLlgA+Bnw+2z8J+AFwGXBItg5poMBfSFK0dqt3NyHBT38KvXrBhRfCmjVw2WXQwwOym1mF5OnFdDtpTKYnaONUo1lymQlsB/wSmAO8HhGrs0MWAMOy9WHAfICIWC1pObAJ8GqT1zwROBFgxIgRbQmn6knw4x9Dz57wox+lJHHFFU4SZlYZeRLElhGxY3tePCLWADtLGgDcAtSVOix7VAvPFb/mFcAVkMZiak9c1UxKo7326gXnnZeSxG9+k5KGmVlnypMg7pK0X0Tc3d43iYjXJd0L7AEMkNQrK0VsCSzMDlsADAcWSOoFbAwsbe97dmUSnHtuSgrnnAOrV8NVVzlJmFnnylN58SBwi6S3JK2QtFJSq91dJQ3OSg5I2gD4BPAMMA04MjtsAnBrtn4bDTfgHQncUyvtD835/vdTaeL3v4djjkmJwsyss+QpQVwEfBh4oo1f2EOBSVk7RA9gckTcIelp4I+Szgf+AVyZHX8lcI2k2aSSw9FteK9u63vfS9VNZ56ZEsS116bB/szMyi1PgpgFPNnWX/PZ3da7lNg/F/hgif1vA0e15T1qxbe/nZLE6aen7q/XXeckYWbllydBLALulXQX6d4GoPVurtaxTjsttUF885vpjuvrr4fevSsdlZl1Z3kSxD+zpXe2WIWcemoqSXz963DkkXDDDWleCTOzcmg1QWTzP1iVOPnkVJL42tfgox+Fe++FPn3Sc9OmpWE8zjijoiGaWTeR507qaZS+H+FjZYnIWvXVr8Ls2XDxxfCRj8D998ODDzYMAGhm1hHyVDGdXrTeBzgCcIfLCrvoolSS+OlPYdttYdUquOUWTzpkZh0nTxXTzCa7/irpvjLFY20wcSLMnQs33ZS2f/xj6NcP6usrG5eZdQ+t3ignaVDRsqmkTwGbd0Js1opp0+C++9I9EhtuCA89lOa1PvLINBmRmdm6yHMn9UxgRvb4d+A0GobotgopnnToxz+G229P90Yccwz8+c+www5w/PHw4ouVjtTMuqo8U45uHRHbZI+jImK/iHigM4Kz5hVPOgTp8YYb4AMfSNVO3/hGuut61KjUPXbJksrGa2Zdj5q7QVrS7sD8iHg52z6W1EA9D/hBRFR8IL36+vqYMWNGpcOoWi++mAb9u+oq6Ns33WR32mmw8caVjszMKknSzIhotbWypRLE5cC72YvtA/wEuBpYTjbctlW3ESPgyivhqadg//3hhz+EbbaB//oveOutSkdnZtWupQTRs6iU8Fngioi4KSLOJk0AZF3EmDGp+mnGjNTD6VvfSlVPRxwBU6Y0PnbatNQ7ysysxQSRzcsA8HHgnqLn8tw/YVVmt91SA/a0aTB8ONx8MxxwAJx9dhoEsNDwvfvulY7UzKpBSwniOuA+SbcCbwF/AZC0HamaybqoffeFv/0Nbr01JYrzz4fNNoODD4ZrrvHNdmaWNJsgIuICUpfWq4C9i4b77gF8vfyhWTlJKSHMng2HHQavvgpvvJG6yZ59NixaVOkIzazSWuzmGhEPRsQtEfFm0b7nI+KR8odmneH+++Evf4Gzzkq9m7bfHi64ALbaCiZMgEcfrXSEZlYpeW6Us26q+Ga7H/4wjeX0/PNw9dXw5S+nITx22SVVOd12W2qnMLPa4QRRw0rdbDd5MixcCJdeCgsWpB5Nc+bAIYfA6NHwi1+kqigz6/6avVGuK/CNcp1j9epUmvjZz9J4TwMGwH/8R5q46LrrUq+n4oZtz0thVt064kY5MyDNYvfZz6Y5J/7+d9hvvzQXxdZbw113weGHp6QA7ipr1p04QVib7LFHmg97zpw0dMc//gGvv56Sxqc/nUaSLa62MrOuywnC2mWrrdJkRfPnwyWXQP/+cOedsHSbPVEPAAAM3klEQVRpauA++eTUsL1iRaUjNbP2coKwddKvXxpBtkePNE/2hhvCJpukAQIPOSSt77NPuhlv+nRYs6bSEZtZXmVLEJKGS5om6RlJT0k6Jds/SNIUSbOyx4HZfkm6RNJsSY9L2rVcsVnHKe4q+8tfpnkpZs9OjdrTpqVxn1atSjffffCDMGRIas+48spU+oDUU6rQhlH8uh4TyqyyylmCWA2cFhF1wB7ASZLGAmcCUyNiFDA12wY4ABiVLScCl5UxNusgzXWVfeyxNKTHj36UBglcsgT+8Id09/YDD8CXvpRGm62rS43fhx6aqqjADd1m1aLTurlmYzr9Ilv2jYhFkoYC90bEaEmXZ+vXZcc/Vziuudd0N9euKQKefhruvjst993XMPz44MGwfDl85jMpwWy7bRqifORIWH/95l9z4kR3tzXLK283104ZlVXSSGAX4CFgs8KXfpYkhmSHDQPmF522INvXKEFIOpFUwmDEiBFljdvKQ0pTou6wQ+oJ9fbbqVRxzjlpEMHBg1P32ZtuanzO8OENCaP4cdttU3IoVHWNG9e46svM2qfsCULSRsBNwKkRsUJSs4eW2LdW8SYiriCbsKi+vr7r3uVn/9KnD/TsmYb5OPtsuOyy1JZRV5emT50zJy2F9dtvX3sK1QEDUvvGAQfAzjvDk0/CKaek0sqzz8LQoamnVfN/fi6FmDVV1gQhaT1Scrg2Im7Odi+WNLSoiqnwX30BMLzo9C2BheWMz6pD8a/9cePSUry9115rn/PGGw0JoziJvPJKutsbUvvHj37UcM4GG8AWW6RkMXTo2uuDB8NRR6X3/djHXAoxK1sbhFJRYRKwNCJOLdr/U+C1iPiJpDOBQRFxhqRPAycDBwIfAi6JiA+29B5ug+geOuqXe+EL/StfSaWQiy5KDeELF6bhywtL8fbKlaVfa8CAlIT23ht23RWGDUvLllumxy22gN69y/M5zMotbxtEORPE3qRJhp4ACuOAfpfUDjEZGAG8CBwVEUuzhPILYH9gFXBcRLT47e8EYQVNSyFNt5vzxhtrJ47Jk1PPqhEjUhJ46aXSc3gPHtyQOIYNg3ffhRtvTEOnH3RQOu8LX/Cd5VZ9Kp4gOoMThBV0dCnkq19NpZDJk1NvqtdfT1/4hWXBgsbbL72Uqrea2npr2HNP2HHHhmXo0JbbQszKzQnCrI3aWwopeOedVAI599x0J/lee6Wqqscfb7gpENLd5cUJY6edYOzY1EbiairrDFXVzdWsK2jupr/p0/MliPXXh3/+E+64o6E3VuH1li2DJ55IyaKw/PrX6S5zSEOVbL89bL55SjDf/S58/vPprvTPf94N5VYZLkGYdZC2lkDefz/1wHrsscaJY+7cxsdtuimMGpXaREaMSPeDFNZHjIBBgxpXWbkUYq1xCcKsk7W1BNKjB2y3XVqOOKJh/8qV6R6O3/0OPvKRdCPgiy/CzJnwpz+lqqxiG2zQOGGsWZOmkP3BD9LQJnPnwr//u0sh1nYuQZhVmVIN5YUEE5Eaw198sfEyf37D+ssvr/2aAwc2lEK22iotxesDBrgUUktcgjDrglq7aVBKd4wPGQL1zfz3fued1Mvq3HPhmmvgox9NpZR581IV1h13pOFNim20UePEsXp1GqL9ggvSsO3PPNP2UoiTTNfnEoRZFSlnd93iUsiSJam0MW9ew2Px+tKla7/mhhum9o/NNkuN6Ztv3rBe/DhkCKy33rr3CuvI62GNuZurWY3qiC/mN95IyeL88+G669K9IDvsAIsXpyqswmNzd6JvsklKGL17p5F7d9opjY91zDHpzvT+/RuWjTduWO/XL82B3pGfxdbmKiazGrWu3XUhVTktXgxTpjR02f3+99c+f9WqdFzTxFH8uMEG8PDD6fjLL2/9vfv2bZw0hg+H/fdP94o89xwcd1y63+T//b9UWhk8OPX0Wm+90q/nUkj7uQRhZmvpqF/uTau6Jk1KpYkVK9Zeli9vft+sWalxXkpVZKUMGtTQPlO8LFuWeoSddx588pOpRPPVr9Z2VZdLEGbWbh1RCmmtwT2vwusUSjJXXgmjR6d2lOaWJ59Mj8VtKaee2vh1Dzww9e7Ks/Tpk7oiX345HHYY/OUvtTHSr0sQZlYWHfGre11LMu+9B6++mkofEyfCtdemOUP23juVLJpbVqxo+XV79Ejzley0U0N34eLHfv3Kcz06ihupzazL64xeXaWsWZMGaHz99caJY9KkNHf6jjumKq1589I9KKtXNz5/wIC1k8bKlXDppWmIlUMPbVwK6eyqLicIMzPK155SOH/NmtQg37TbcPHj8uVrv56UugVvuWVKNpts0vBYvF6875FH4Oij1/2zuA3CzIzOaU8pzAny4Q+XPn/58oaE8atfpTnX6+vTAI2vvZbaSubMSY/LljUfR48eqYfZJz+ZbmC8//7ydvl1CcLMrBWdWdW1Zk1KEkuXNiSPpo/33pt6Y519duqd1VauYjIzqyLlrupqi7wJokfbXtbMzNqjpaquvIqTynnnpcfx49P+cnAJwsysi3AvpjZwgjAzaztXMZmZ2TpxgjAzs5KcIMzMrCQnCDMzK8kJwszMSurSvZgkvQLMq3QcrdgUeLXSQeTgODtWV4kTuk6sjrPjbBURg1s7qEsniK5A0ow83ckqzXF2rK4SJ3SdWB1n53MVk5mZleQEYWZmJTlBlN8VlQ4gJ8fZsbpKnNB1YnWcncxtEGZmVpJLEGZmVpIThJmZleQEsY4kDZc0TdIzkp6SdEqJY/aVtFzSo9ny/UrEmsXygqQnsjjWGgpXySWSZkt6XNKuFYhxdNG1elTSCkmnNjmmYtdU0m8lLZH0ZNG+QZKmSJqVPQ5s5twJ2TGzJE2oQJw/lfRs9m97i6QBzZzb4t9JJ8T5A0kvFf37HtjMuftLei77ez2zAnFeXxTjC5IebebcTrueHSoivKzDAgwFds3W+wHPA2ObHLMvcEelY81ieQHYtIXnDwTuAgTsATxU4Xh7Ai+TbuypimsK7APsCjxZtG8icGa2fiZwYYnzBgFzs8eB2frATo5zP6BXtn5hqTjz/J10Qpw/AE7P8bcxB9gG6A081vT/XrnjbPL8RcD3K309O3JxCWIdRcSiiHgkW18JPAMMq2xU6+QQ4OpIHgQGSBpawXg+DsyJiKq5Yz4i7geWNtl9CDApW58EHFri1E8BUyJiaUQsA6YA+3dmnBFxd0SszjYfBLYs1/vn1cz1zOODwOyImBsR7wJ/JP07lEVLcUoSMB64rlzvXwlOEB1I0khgF+ChEk9/WNJjku6StEOnBtZYAHdLminpxBLPDwPmF20voLIJ72ia/09XLdcUYLOIWATpRwMwpMQx1XZtjyeVFktp7e+kM5ycVYX9tpkqu2q6nh8BFkfErGaer4br2WZOEB1E0kbATcCpEbGiydOPkKpIdgIuBf7U2fEV2SsidgUOAE6StE+T51XinIr0hZbUGzgYuKHE09V0TfOqpmv7PWA1cG0zh7T2d1JulwHbAjsDi0jVN01VzfUEPkfLpYdKX892cYLoAJLWIyWHayPi5qbPR8SKiHgjW78TWE/Spp0cZiGWhdnjEuAWUjG92AJgeNH2lsDCzoluLQcAj0TE4qZPVNM1zSwuVMVlj0tKHFMV1zZrHD8I+EJkFeRN5fg7KauIWBwRayLifeDXzbx/tVzPXsDhwPXNHVPp69leThDrKKt7vBJ4JiIubuaYzbPjkPRB0nV/rfOi/FccG0rqV1gnNVg+2eSw24Bjs95MewDLC1UnFdDsr7JquaZFbgMKvZImALeWOObPwH6SBmZVJvtl+zqNpP2BbwMHR8SqZo7J83dSVk3avQ5r5v2nA6MkbZ2VNo8m/Tt0tk8Az0bEglJPVsP1bLdKt5J39QXYm1SsfRx4NFsOBL4CfCU75mTgKVIviweBPSsU6zZZDI9l8Xwv218cq4BfknqHPAHUVyjWvqQv/I2L9lXFNSUlrUXAe6RfsScAmwBTgVnZ46Ds2HrgN0XnHg/MzpbjKhDnbFK9feFv9X+yY7cA7mzp76ST47wm+/t7nPSlP7RpnNn2gaSeg3MqEWe2/6rC32XRsRW7nh25eKgNMzMryVVMZmZWkhOEmZmV5ARhZmYlOUGYmVlJThBmZlaSE4RZB5I0sni0T7OuzAnCzMxKcoIwKxNJ20j6h6TdKx2LWXs4QZiVgaTRpPG5jouI6ZWOx6w9elU6ALNuaDBpLKYjIuKpSgdj1l4uQZh1vOWk8Y72qnQgZuvCJQizjvcuaUa5P0t6IyL+UOmAzNrDCcKsDCLiTUkHAVMkvRkRpYb/NqtqHs3VzMxKchuEmZmV5ARhZmYlOUGYmVlJThBmZlaSE4SZmZXkBGFmZiU5QZiZWUn/H3eXqsQwf8rdAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "\n",
    "plt.plot(range(1,20), distortions, 'bx-')\n",
    "plt.xlabel('k')\n",
    "plt.ylabel('Sum of squared distances')\n",
    "plt.title('Elbow Method For Optimal k')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
